﻿	CREATE TABLE public.privilege
	(
	    /***************************************************************************************************
	    **  Table:	    public.privilege
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    Represents a registered privilege.
	    **
	    **  Fields (2):
	    **
	    **      id      - candidate key
	    **      name    - username
	    **
	    **  Constaints (2):
	    **
	    **      privilege_pk  - 
	    **      privilege_uc  - 
	    **      
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    id                  integer                 NOT NULL DEFAULT nextval('privilege_id_seq'),
	    name                character varying(128)  NOT NULL,
        
	    -- [Constraints]
	    CONSTRAINT privilege_pk   PRIMARY KEY ("id"),
	    CONSTRAINT privilege_uc   UNIQUE ("name")
	);